JDBCAPI连接数据库

JDBCAPI连接数据库java.sql提供的接口DriverManager:负责创建连接的驱动管理器Connection:数据库连接对象Statement:执行sql语句对象PreparedStatement:具有预定义的SQL语句对象ResultSet：SQL语句查询结果集//jdbc连接数据库的程序packagejdbc;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassTestJdbc{publicstaticvoidmain(String[]args){Connectionconn=null;Statementstmt=null;ResultSetrs=null;try{//实例化数据驱动程序Class.forName(com.mysql.jdbc.Driver);//数据库连接地址Stringurl=jdbc:mysql://localhost:3306/zl_two;//数据库用户名，密码conn=DriverManager.getConnection(url,root,root);//提交sql语句，创建Statement对象stmt=conn.createStatement();//执行查询语句rs=stmt.executeQuery(select*fromstudent);while(rs.next()){System.out.println(rs.getString(UserName)++rs.getString(UserAddress));}//stmt.executeUpdate(insertintostudent(UserName,UserPwd,UserRole,UserAddress)values('zhangsi1','111',0,'shenzhen'));//stmt.executeUpdate(updatestudentsetUserName='zhaoliang'whereUserPwd='111');//stmt.executeUpdate(deletefromstudentwhereUserName='zhaoliang');}catch(SQLExceptione){e.printStackTrace();}catch(ClassNotFoundExceptione){e.printStackTrace();}finally{try{rs.close();stmt.close();conn.close();}catch(SQLExceptione){e.printStackTrace();}}}}