jdb操作顺序

1.加载驱动
try{
class.forname(“com.mysql.jdbc.driver”);
} catch (ClassNotFoundException e){
e.printStackTrace();
}

2.创建链接
Try{
Connection connection=DriverManager.getConnection
(url:”………”)
} catch (SQLException e){
e.printStackTrace();}
System.out.peintln(“111111”);

3.写sql
String sql=“select * from student where username=? and password=?”;
System.out.println(“请输入用户名：”);
String name=input.next();
System.out.println(“请输入密码：”);
String password=input.next();

4.得到statement
statement=connection.preparedStatement(sql);
statement.setString(parameterindex:1,x=“123”);
statement.setString(parameterindex:2,x=“123”);
ResultSet resultSet=statment.executeQuery();
if(resultSet next()){
System.out.println(“登陆成功”);
}else{
throw new loginException(“用户密码不对”)；
}

 }      catch (SQLException e)  {
            e.printStackTrace();
 }  finally{
            if(resultSet!=null){
                  try{resultSet.close();
                  } catch (SQLException e){
                       e.printStackTrace();
                  }
 }
  if(statement!=null){
                  try {
                       ststement.close();
                  } catch (SQLException e){
                       e.printStackTrace();
                 }                                               
}
 if(!=null){
                  try {
                       ststement.close();
                  } catch (SQLException e){
                       e.printStackTrace();
                 }                                               
}

    System.out.println(“111111”);

public class TestFile{
public static void main(string[] args) throws IOException {
File file=new File( pathname:”D:\工作\aaa.txt”);
file.createNewFile();

       File file1=new File( pathname:”D:\\工作\\bbb.txt”);
       file.renameTofile1);

       System.out.println(file);
  } 

}