一.(数据库连接) 增、删、查、改
1.数据库连接:
(1)加载驱动:
Sqlserver:String Driver= “ com.microsoft.sqlserver.jdbc.SQLServerDriver”;
Oracle: String Driver=”oracle.jdbc.driver.OracleDriver”;
Class.forName(Driver);--加载
(2)创建连接:
Connectionconn=DriverManager.getConnection(URL,USER,PASSWORD);
(3)创建String 对象编写需要操作的sql语句
String sql=” xxxxx”;
(4)创建对象操作对象操作数据库中数据
PreparedStatementprep=conn.prepareStatement(sql);
(5)执行操作:
à返回结果的,即查询语句,:
先执行
ResultSetrs=prep.executeQuery();
然后获取结果集中的数据:while(rs.next()){rs.getInt(“uid”);}(注:对应类型和字段名)
à无需返回结果的:
先对于sql语句中的问号传值:prep.setInt(1,uid);(注:1表示第一个问号,uid为变量名注意问号对应数据库字段的类型)
然后执行
prep.execute();
2.对user表进行增、删、查、改(表中有三个字段uid,uname,upassword,其中uid 为自动增长) :
Sqlserver:
StringURL=”jdbc:sqlserver://localhost:1433;databaseName=test1”;
String Driver= “com.microsoft.sqlserver.jdbc.SQLServerDriver”;
Oracle:
StringURL="jdbc:oracle:thin:@localhost:1521:orcl";---oracle
StringDriver="oracle.jdbc.driver.OracleDriver";
StringUser="xxxx";
Stringpassword="xxx";
publicConnection getConn(){
Class.forName(Driver);
Connection conn=DriverManager.getConnection(URL,User,password);
returnconn;
}
增:
public void insertDemo(String name, String password){
connectionconn=getConn();
String sql=”insert intouser values(?,?)”;
PreparedStatementprep=conn.prepareStatement(sql);
prep.setString(1,name);
prep.setString(2,password);
prep.execute();
}
删:
public void deleteDemo(){
connection conn=getConn();
String sql=”delete user”;
PreparedStatementprep=conn.prepareStatement(sql);
prep.execute();
}
查:
public void selectDemo(String name, String password){
connection conn=getConn();
String sql=”select *from user ”;
PreparedStatementprep=conn.prepareStatement(sql);
ResultSetrs=prep.executeQuery();
while(rs.next()){
system.out.println(rs.getString(“uname”)+”“+rs.getString(“upassword”));
}
}
改:
public void updateDemo(int id,String name, Stringpassword){
connection conn=getConn();
String sql=”update userset uname=?,upassword=? where uid=?”;
PreparedStatementprep=conn.prepareStatement(sql);
prep.setString(1,name);
prep.setString(2,password);
prep.setInt(3,id);
prep.execute();
}