Java method for accessing mysql database, javamysql Database

Java method for accessing mysql database, javamysql Database

1. Download the interface package mysql-connector-java-5.0.8-bin.jar

2. Programming

(1) load the driver

(2) programming connection operations

(3) return result Processing

Programming example

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 resultsetString 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 tablesql="insert into student(name,major,score) values('f','Chinese','70');";try {stam.execute(sql);} catch (SQLException e) {e.printStackTrace();}//delete something from the tablesql="delete from student where name='f';";try{stam.executeUpdate(sql);}catch(SQLException e){e.printStackTrace();}//change the data int the tablesql="update student set score=100 where name='a' and major='Chinese'";try{stam.executeUpdate(sql);}catch(SQLException e){e.printStackTrace();}//prepared statementsql="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 programtry{res.close();pstam.close();stam.close();conn.close();}catch(SQLException e){e.printStackTrace();}}}

Adjust the code as needed