JDBC模板

来源：互联网发布：virtualbox安装centos 编辑：程序博客网时间：2024/06/06 12:59

import java.sql.*;public class TestJDBC {public static void main(String[] args) throws Exception{//1. Load the Driver//->1 Class.forName()|Class.forNmae().newInstance()|new DriverName()//->2 实例化时自动向DriverManager注册,不需要显示调用DriverManager.registerDriver方法Class.forName("oracle.jdbc.driver.OracleDriver");//new oracle.jdbc.driver.OracleDriver();//2. Connect to the DataBase//-> DriverManager.getConnection()Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1522:ORCL", "scott","tiger");//3. Execute the SQL//->1 Connection.createStatement()//->2 Statement.executeQuery()//->3 Statement.executeUpdate()Statement stat=conn.createStatement();ResultSet rs=stat.executeQuery("select * from emp");//4. Retrieve the result data//-> 循环取得结果 while(rs.next())while(rs.next()) {//5. Show the result data//->将数据库中的各种烈性转换为Java中的类型(getXXX)方法System.out.println(rs.getString("ENAME"));System.out.println(rs.getString("JOB"));}//6.Close//-> close the ResultSet/ close the statement /close the connectionrs.close();stat.close();conn.close();}}

下面是mysql时的情况，稍微一点点不同。

Class.forName("com.mysql.jdbc.Driver");Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test");PreparedStatement pstat=conn.prepareStatement("select * from member where mid=?");pstat.setString(1, id);ResultSet rs=pstat.executeQuery();if(rs.next()) {rs.close();conn.close();return "false";}

获取mysql端口号的方法：

mysql> show variables like 'port';+---------------+-------+| Variable_name | Value |+---------------+-------+| port          | 3306  |+---------------+-------+1 row in set (0.00 sec)mysql>