jdbctest.java

来自「自己写的关于Java与数据库连接（以mysql为例）的时候的最底层的设置方案」· Java 代码 · 共 65 行

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class JdbcTest{
	private String driver="com.mysql.jdbc.Driver";
	private String url="jdbc:mysql://localhost:3306/test1"; 
	private String user="root";
	private String password="root";
//	private String url="jdbc:mysql://localhost:3306/test;user='root';password='root'";
	Connection conn=null;
	PreparedStatement pstmt=null;
	ResultSet rs=null;
	public void display(){
			try{
					Class.forName(driver);
					conn=DriverManager.getConnection(url,user,password);
					if(conn!=null){
							System.out.println("连接成功");
						}
					pstmt=conn.prepareStatement("update friends set salary=? where name like ?");
					pstmt.setInt(1, 55555);
					pstmt.setString(2, "%四%");
					pstmt.executeUpdate();
					System.out.println("数据已经更新");
					Statement stmt=conn.createStatement();
					rs=stmt.executeQuery("select * from friends");
					while(rs.next()){
						System.out.print(rs.getInt(1)+"\t");
						System.out.print(rs.getInt(6));
						System.out.println();
					}
				}
				catch(Exception e){
						e.printStackTrace();
						System.out.println("内的错误跟踪"+e.getMessage());
						System.out.println(e);
					}
				finally{
					try{
						if(rs!=null){
							rs.close();
						}
						if(pstmt!=null){
							pstmt.close();
						}
						if(rs!=null){
							rs.close();
						}
					}
					catch(SQLException e1){
						e1.printStackTrace();
					}
				}
					
		}
	public static void main(String[] args){
		JdbcTest jt=new JdbcTest();
		jt.display();
	}
}