- 浏览: 28456 次
最新评论
一阶段-nineteenthwork-数据库操作-用心做程序-iteye技术网站
2011年08月01日
/*
在任意数据库中建立表 userinfo 包含字段 Username varchar(10), password varchar(10);
1. 编写java类实现使用Statement类实现用户登录操作,控制台输入用户名和密码
2. 编写java类实现使用PreparedStatement 实现用户登录操作,控制台输入用户名和密码 登录成功之后依次实现:
a. 增加用户 *控制台输入用户名和密码
b. 修改用户密码 *控制台输入用户名,修改指定用户名的密码
c. 删除用户 *控制台输入用户名,删除指定用户名的密码
d. 查询所有用户信息
*/
package nineteenthWork;
public class RunMain
{
public static void main(String[] args)
{
DriverStep driver = new DriverStep();
driver.run();
}
}
=====================================
package nineteenthWork;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
/**
*
* @author Administrator
*/
public class DriverStep
{
private String yesNo="";
public void run()
{
UserVO vo = new UserVO();
LoginFrame log = new LoginFrame();
UserinfoDao jddao = new UserinfoDao();
System.out.println("-------------请先登录!-----------");
log.Login(vo);//用"张三","123"登录成功
if(!jddao.resultLog(vo))
{
System.exit(0);
}
System.out.println("是否要增加新用户,请输入'是'或者'否': ");
BufferedReader buff = new BufferedReader(new InputStreamReader(System.in));
try {
yesNo = buff.readLine();
} catch (IOException ex) {
ex.printStackTrace();
}
if(yesNo.equals("是"))
{
log.inintUser(vo);//增加用户
}
System.out.println("是否要执行修改某用户密码的操作,请输入'是'或者'否': ");
try {
yesNo = buff.readLine();
} catch (IOException ex) {
ex.printStackTrace();
}
if(yesNo.equals("是"))
{
log.inintUpdatePasswork(vo);//修改密码
}
System.out.println("是否要执行删除某用户密码的操作,请输入'是'或者'否': ");
try {
yesNo = buff.readLine();
} catch (IOException ex) {
ex.printStackTrace();
}
if(yesNo.equals("是"))
{
log.inintDeletePassword(vo);//删除密码
}
System.out.println("是否要执行查询所有用户信息的操作,请输入'是'或者'否': ");
try {
yesNo = buff.readLine();
} catch (IOException ex) {
ex.printStackTrace();
}
if(yesNo.equals("是"))
{
log.resultSelectAll();//查询所有用户信息
}
System.out.println("程序执行完毕");
}
}
==========================================
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package nineteenthWork;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author Administrator
*/
public class Factory
{
Connection conn = null;
public Connection getConn()
{
try {
String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String URL = "jdbc:sqlserver://John:1433;databaseName=students; user=john;password=123";
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL);
} catch (ClassNotFoundException ex) {
Logger.getLogger(Factory.class.getName()).log(Leve l.SEVERE, null, ex);
} catch (SQLException ex) {
ex.printStackTrace();
}
return conn;
}
public void close()
{
if(conn != null)
{
try {
conn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
}
==================================
package nineteenthWork;
import java.sql.*;
public class JdbcStatementDAO
{
public boolean logData(UserVO vo)
{
boolean activity = false;
try {
Factory factory = new Factory();
Connection conn = factory.getConn();
Statement stmt = conn.createStatement();
// String sql = "select * from userinfo where username='"+vo.getUsername()+"' and password ='"+vo.getPassword()+"'";
String username = vo.getUsername();
String password = vo.getPassword();
String sql = "select * from userinfo where username='"+username+"' and password ='"+password+"'";
ResultSet rs = stmt.executeQuery(sql);
activity = rs.next();
} catch (Exception ex) {
System.out.println(ex.toString());
}
return activity;
}
}
==================================
package nineteenthWork;
import java.io.BufferedReader;
import java.io.InputStreamReader;
public class LoginFrame
{
public void Login(UserVO vo)//验证登录结果
{
// JdbcStatementDAO info = new JdbcStatementDAO();//这是Statement的实现方法
UserinfoDao info = new UserinfoDao();//这是PreParedStatement的实现方法
BufferedReader buff = new BufferedReader(new InputStreamReader(System.in));
try{
System.out.println("请输入登录名: ");
vo.setUsername(buff.readLine()) ;
System.out.println("请输入密码: ");
vo.setPassword(buff.readLine());
if(info.resultLog(vo))
{
System.out.println("登录成功!");
}
else{
System.out.println("登录失败!");
}
}catch(Exception e)
{
System.out.println();
}
}
public void inintUser(UserVO vo)//新增用户信息
{
UserinfoDao info = new UserinfoDao();//这是PreParedStatement的实现方法
BufferedReader buff = new BufferedReader(new InputStreamReader(System.in));
try{
System.out.println("请输入新登录名: ");
vo.setUsername(buff.readLine()) ;
System.out.println("请输入密码: ");
vo.setPassword(buff.readLine());
if(info.insertUser(vo))
{
System.out.println("注册成功!");
}
else{
System.out.println("注册失败!");
}
}catch(Exception e)
{
System.out.println();
}
}
public void inintUpdatePasswork(UserVO vo)//修改某用户的密码
{
UserinfoDao info = new UserinfoDao();//这是PreParedStatement的实现方法
BufferedReader buff = new BufferedReader(new InputStreamReader(System.in));
try{
System.out.println("请输入要修改的用户名: ");
vo.setUsername(buff.readLine()) ;
System.out.println("请输入新密码: ");
vo.setPassword(buff.readLine());
if(info.updatePassword(vo))
{
System.out.println("修改成功!");
}
else{
System.out.println("修改失败!");
}
}catch(Exception e)
{
System.out.println();
}
}
public void inintDeletePassword(UserVO vo)//删除某用户的密码
{
UserinfoDao info = new UserinfoDao();//这是PreParedStatement的实现方法
BufferedReader buff = new BufferedReader(new InputStreamReader(System.in));
try{
System.out.println("请输入你想要删除的用户的用户名: ");
vo.setUsername(buff.readLine()) ;
// System.out.println("请输入该用户的密码: ");
// vo.setPassword(buff.readLine());
if(info.deletePassword(vo))
{
System.out.println("删除密码成功!");
}
else{
System.out.println("删除密码失败!");
}
}catch(Exception e)
{
System.out.println();
}
}
public void resultSelectAll()//查询所有用户的信息
{
UserinfoDao info = new UserinfoDao();//这是PreParedStatement的实现方法
info.selectAll();
}
}
=================================
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package nineteenthWork;
/**
*
* @author Administrator
*/
public class UserVO
{
private String username;
private String password;
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
}
===========================================
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package nineteenthWork;
import java.sql.*;
/**
*
* @author Administrator
*/
public class UserinfoDao
{
public boolean resultLog(UserVO vo)//返回登录结果
{
boolean activity = false;
Factory factory = new Factory();
try{
Connection conn = factory.getConn();//获取连接数据库
String sql = "select * from userinfo where username=? and password =?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, vo.getUsername());
ps.setString(2, vo.getPassword());
ResultSet rs = ps.executeQuery();
activity = rs.next();
}
catch(Exception e)
{
System.out.println(e.toString());
}finally{
factory.close();//关闭数据连接
}
return activity;
}
public boolean insertUser(UserVO vo)//增加新的用户信息
{
Factory factory = new Factory();
boolean activity = false;
try{
Connection conn = factory.getConn();
// String username = vo.getUsername();
// String password = vo.getPassword();
String sql = "insert into userinfo (username,password)values(?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, vo.getUsername());
ps.setString(2, vo.getPassword());
int i = ps.executeUpdate();
System.out.println("影响行数:"+i+"行");
if(i>0)
{
activity = true;
}
}
catch(Exception e)
{
System.out.println(e.toString());
}finally{
factory.close();
}
return activity;
}
public boolean updatePassword(UserVO vo)//修改用户的密码
{
Factory factory = new Factory();
boolean activity = false;
try{
Connection conn = factory.getConn();
String sql = "update userinfo set password=? where username=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, vo.getPassword());
ps.setString(2, vo.getUsername());
int i = ps.executeUpdate();
System.out.println("影响行数:"+i+"行");
if(i>0)
{
activity = true;
}
}
catch(Exception e)
{
System.out.println(e.toString());
}finally{
factory.close();
}
return activity;
}
public boolean deletePassword(UserVO vo)//删除某用户的密码
{
boolean activity = false;
Factory factory = new Factory();
try{
Connection conn = factory.getConn();
String sql = "update userinfo set password=null where username=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, vo.getUsername());
int i = ps.executeUpdate();
System.out.println("影响行数:"+i+"行");
if(i>0)
{
activity = true;
}
}
catch(Exception e)
{
System.out.println(e.toString());
}finally{
factory.close();
}
return activity;
}
public boolean selectAll()//查询表userinfo中所有用户的信息
{
boolean activity = false;
Factory factory = new Factory();
try {
Connection conn = factory.getConn();
String sql = "select * from userinfo";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next())
{
System.out.println(rs.getString("username")+"\t"+r s.getString("password"));
activity = true;
}
} catch (SQLException ex) {
ex.printStackTrace();
}finally{
factory.close();
}
return activity;
}
}
发表评论
-
字符串相关方法
2012-07-06 09:51 506字符串相关方法使 ... -
JavaScript用正则表达式验证表单
2012-07-06 09:44 651验证表单的不同内容用的是不同的正则表达式。 常用的正则 ... -
Actionscript正则表达式(二)
2012-07-06 09:36 1583Actionscript正则表达 ... -
Winform Change skin(DevExpress commerical commponents)
2012-07-06 09:29 1199Create a basic Form public pa ... -
【资料整理】Javascript中getElementsByName()和getElementById()的区别和用法
2012-07-05 20:44 584getElementsByName()定义和用法 ge ... -
重写Flex组件
2012-07-03 13:42 521一、为什么要重写 ... -
重写Flex组件
2012-07-03 12:15 511一、为什么要重写 ... -
Flex 动态datagrid的应用
2012-07-02 10:08 631Style Definitions */ p.MsoNor ... -
Flex 数据易犯错误: 常见误用和错误
2012-07-02 10:07 527在某些情形下,绑定操作似乎不能正常工作,此时你可能非常懊恼 ... -
Hello,Flex
2012-07-02 09:41 406... -
Qt学习之路(53): 拖放技术之二
2012-07-01 09:25 757很长时间没有来写博客了,前段时间一直在帮同学弄一个 spr ... -
通过Flash实现ASP.NET多文件上传
2012-07-01 09:24 732关于多文件上传, ... -
设置手机项目首选参数
2012-07-01 09:24 742Flash Builder 使用设 ... -
关于ActionScript 3.0 中方法重写和继承的发现
2012-07-01 09:24 612子类: package { import mx.contr ... -
flex 第三方库 大全
2012-06-30 11:11 562flex 第三方库 大全 2011年11月17日 下面总 ... -
Adobe Flex
2012-06-30 11:11 496Adobe Flex 2010年08月15日 ... -
Flex Builder2的基本知识[转]
2012-06-30 11:11 503Flex Builder2的基本知识[ ... -
Flex RSL
2012-06-30 11:11 553Flex RSL 2010年11月02日 ... -
memcached完全剖析
2012-01-20 08:31 598memcached完全剖析 2011年0 ... -
把Linux中的VFS对象串联起来
2012-01-20 08:31 919把Linux中的VFS对象串联起来 2010年06月21日 ...
相关推荐
Spring的JdbcTemplate插入操作返回主键ID的方法 - - ITeye技术网站
eclipse开发环境(支持tomcat、maven、jetty、JBoss) - - ITeye技术网站
深入浅出CGlib-打造无入侵的类代理 - llying - ITeye技术网站
博文链接:https://java-xiaodi.iteye.com/blog/138111
js中escape对应的C#解码函数 - Corrinejtt - ITeye
javaMD5加密及登录验证(备忘) - Hibernate - Java - ITeye论坛.mhtjavaMD5加密及登录验证(备忘) - Hibernate - Java - ITeye论坛.mhtjavaMD5加密及登录验证(备忘
ice最简单实现 ruby调用ice接口 - Ruby - language - ITeye论坛
java_web开发_高并发处理_-_-_ITeye技术网站.pdf
NULL 博文链接:https://gaojiewyh.iteye.com/blog/411889
NULL 博文链接:https://serisboy.iteye.com/blog/1611985
NULL 博文链接:https://201304021822.iteye.com/blog/1853334
NULL 博文链接:https://flyer0126.iteye.com/blog/492403
2. ... 3. }] 1. { 4. }, 6. } 2. didReceiveRemoteNotification:(NSDictionary *)use
VMware-Horizon-Agent-x86_64-7.6.0-9539447
tomcat6使用DBCP和blob出现ClassCastException解决方法
NULL 博文链接:https://chenjingbo.iteye.com/blog/916577
NULL 博文链接:https://springlin.iteye.com/blog/1520668