import java.sql.*;
java数据库访问具体步骤
1、加载数据库(注册数据库)
Class.forName();对应库需要到对应网站上下载jar
Class.forName("com.mysql.jdbc.Driver").newInstance();//MySQL数据库
Class.forName("Oracle.jdbc.driver.OracleDriver").newInstance(); //Oracle8/8i/9iO数据库(thin模式)
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //Sql Server7.0/2000数据库
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //Sql Server2005/2008数据库
Class.froName("com.ibm.db2.jdbc.app.DB2Driver").newInstance(); //DB2数据库
2、建立数据库连接
String url="jdbc:mysql://localhost:3306/testDB"; //Mysql
String url="jdbc:db2://localhost:5000/testDB"; //DB2
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //Sql Server7.0/2000/2005/2008数据库
String url="jdbc:oracle:thin:@localhost:1521:orcl"; //Oracle
String user = "root";
String Password = "password";
Connection conn = DriverManager.getConnection(url,user,password);
3、调用数据库语句SQL
静态执行SQL语句
Statement stmt=conn.createStatement();
String sql="select * from user";
ResultSet rs = stmt.executeQuery(sql);
动态执行SQL语句
String sql="select * from user where userName=? and password=?";
PreparedStatement pstmt=Conn.prepareStatement(sql);
pstmt.setString(1,"admin");
pstmt.setString(2,"password");
ResultSet rs = pstmt.executeQuery();
4、处理结果
访问ReseltSet rs
while(rs.next)
{
system.out.print(rs.getString("namen"));
system.out.print(rs.getString(2));
}
5、关闭数据库
关闭顺序ResultSet、Statement(PreparedStatement)Connection
rs.close stmt.clost(); pstmt.close(); con.close();
java数据库访问具体步骤
1、加载数据库(注册数据库)
Class.forName();对应库需要到对应网站上下载jar
Class.forName("com.mysql.jdbc.Driver").newInstance();//MySQL数据库
Class.forName("Oracle.jdbc.driver.OracleDriver").newInstance(); //Oracle8/8i/9iO数据库(thin模式)
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //Sql Server7.0/2000数据库
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //Sql Server2005/2008数据库
Class.froName("com.ibm.db2.jdbc.app.DB2Driver").newInstance(); //DB2数据库
2、建立数据库连接
String url="jdbc:mysql://localhost:3306/testDB"; //Mysql
String url="jdbc:db2://localhost:5000/testDB"; //DB2
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; //Sql Server7.0/2000/2005/2008数据库
String url="jdbc:oracle:thin:@localhost:1521:orcl"; //Oracle
String user = "root";
String Password = "password";
Connection conn = DriverManager.getConnection(url,user,password);
3、调用数据库语句SQL
静态执行SQL语句
Statement stmt=conn.createStatement();
String sql="select * from user";
ResultSet rs = stmt.executeQuery(sql);
动态执行SQL语句
String sql="select * from user where userName=? and password=?";
PreparedStatement pstmt=Conn.prepareStatement(sql);
pstmt.setString(1,"admin");
pstmt.setString(2,"password");
ResultSet rs = pstmt.executeQuery();
4、处理结果
访问ReseltSet rs
while(rs.next)
{
system.out.print(rs.getString("namen"));
system.out.print(rs.getString(2));
}
5、关闭数据库
关闭顺序ResultSet、Statement(PreparedStatement)Connection
rs.close stmt.clost(); pstmt.close(); con.close();