java窗体控实现登陆功能_Java JDBC控制台实现登录 2020-08-28

Version:1.0StartHTML:0000000105EndHTML:0000007659StartFragment:0000000127EndFragment:0000007641

packagecom.zx.test1;

importjava.sql.*;

importjava.util.Scanner;

publicclassDemo4 {

publicstaticvoidmain(String[] args) {

Connection connection =null;

PreparedStatement ps =null;

ResultSet resultSet =null;

try{

//键盘录入账号和密码：

Scanner sc =newScanner(System.in);

System.out.println("---欢迎进入登录界面---");

System.out.print("账号：");

String name = sc.next();

System.out.print("密码：");

String pwd = sc.next();

//1.加载驱动

Class.forName("com.mysql.jdbc.Driver");

//2.连接sql

connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/company","root","root");

//3.创建会话并且预编译sql

ps = connection.prepareStatement("select * from t_user where username=? and pwd=?");

//?相当于占位符

//4.设置？的值：

ps.setString(1,name);

ps.setString(2,pwd);

//5.执行sql语句

resultSet = ps.executeQuery();

//6.处理结果

//6.1让游标向下移动一行

if(resultSet.next()){// 判断是否有数据

System.out.println("登录成功");

}else{

System.out.println("登录失败，请查看用户或者密码是否录入错误");

}

}catch(ClassNotFoundException e) {

e.printStackTrace();

}catch(SQLException throwables) {

throwables.printStackTrace();

}finally{

//7.释放资源

if(ps !=null){

try{

ps.close();

}catch(SQLException throwables) {

throwables.printStackTrace();

}

if(connection !=null){

try{

connection.close();

}catch(SQLException throwables) {

throwables.printStackTrace();

}

if(resultSet !=null){

try{

resultSet.close();

}catch(SQLException throwables) {

throwables.printStackTrace();

}

}

}

}

}

}

}