java訪問mysql數據庫的方法

java訪問mysql數據庫的方法

1、下載接口程序包mysql-connector-java-5.0.8-bin.jar 下載地址

2、編程

（1）加載驅動

（2）編程連接操作

（3）返回結果處理

編程示例

import java.sql.*;

public class Access2Database{
	public Connection getConn(){
		Connection conn=null;
		try{
			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://localhost:3306/mytest";
			String user="root";
			String password="111";
			conn=DriverManager.getConnection(url, user, password);
			if(conn!=null){
				System.out.println("The connection to database is successful!");
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		return conn;
	}
	
	public ResultSet getResultSet(Statement stam,String sql){
		ResultSet res=null;
		try {
			res=stam.executeQuery(sql);
		} catch (SQLException e){
			e.printStackTrace();
		}
		return res;
	}
	void showResultSet(ResultSet res){}
}

import java.sql.*;

public class GetConnection{
	public static void main(String[] args){
		Access2Database adb=new Access2Database();
		Connection conn=adb.getConn();
		Statement stam=null;
		try {
			stam = conn.createStatement();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		
		//show resultset
		String sql="select * from student;";
		ResultSet res=adb.getResultSet(stam, sql);
		try {
			System.out.println("name\tmajor\tscore");
			while(res.next()){
				String name,major;
				int score;
				name=res.getString(1);
				major=res.getString(2);
				score=res.getInt(3);
				System.out.println(name+"\t"+major+"\t"+score);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try{
		res.close();
		}catch(SQLException e){
			e.printStackTrace();
		}
		
		//insert something into table
		sql="insert into student(name,major,score) values('f','Chinese','70');";
		try {
			stam.execute(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		//delete something from the table
		sql="delete from student where name='f';";
		try{
			stam.executeUpdate(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
		
		//change the data int the table
		sql="update student set score=100 where name='a' and major='Chinese'";
		try{
			stam.executeUpdate(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
		
		//prepared statement
		sql="select * from student where name=?";
		PreparedStatement pstam=null;
		try {
			pstam=conn.prepareStatement(sql);
			pstam.setString(1, "a");
			res=pstam.executeQuery();
			System.out.println("**********************");
			while(res.next()){
				String name,major;
				int score;
				name=res.getString(1);
				major=res.getString(2);
				score=res.getInt(3);
				System.out.println(name+"\t"+major+"\t"+score);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		//release the resource of the program
		try{
			res.close();
			pstam.close();
			stam.close();
			conn.close();
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
}