java串連mysql資料庫範例

標籤：

package packagename;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 classname {    public static String url = "jdbc:mysql://localhost:3306/test";//characterEncoding=GBK    public static String username = "root";    public static String password = "root";    public static Connection con;    public static Statement stmt;    public static ResultSet rs;    public static PreparedStatement pstmt;        public static void main(String[] args) throws SQLException {        connect();        //select();        //insert();        //update();        //delete();        close();    }    public static void connect() {        // 定位驅動        try {            Class.forName("com.mysql.jdbc.Driver");            System.out.println("載入驅動成功!");         } catch (ClassNotFoundException e) {            System.out.println("載入驅動失敗!");            e.printStackTrace();        }        // 建立串連        try {            con = DriverManager.getConnection(url, username, password);            stmt = con.createStatement();            System.out.println("資料庫連接成功!");         } catch(SQLException e) {            System.out.println("資料庫連接失敗!");            e.printStackTrace();        }    }    public static void select() {        try {                  String sql="select * from test where name=? ";             pstmt=con.prepareStatement(sql);            pstmt.setString(1,"root");          //String sql="select * from test where name=‘root‘ ";             //rs = stmt.executeQuery(sql);           rs=pstmt.executeQuery();            while (rs.next()) {             System.out.println("你的第一個欄位內容為："+rs.getString("name"));              System.out.println("你的第二個欄位內容為："+rs.getInt(1));             }            rs.close();        }catch (Exception e) {            System.out.println("資料查詢失敗!");            e.printStackTrace();        }    }    public static void insert() {        try {         String sql="insert into test (id,name) values(‘2‘,‘admin‘)";         stmt.executeUpdate(sql);            System.out.println("資料插入成功!");        }catch (Exception e) {            System.out.println("資料插入失敗!");            e.printStackTrace();        }            }    public static void update() {        try {         String sql="update test set name=‘rootroot‘ where id=1";            stmt.executeUpdate(sql);            System.out.println("資料更新成功!");        }catch (Exception e) {            System.out.println("資料更新失敗!");            e.printStackTrace();        }    }    public static void delete() {        try {         String sql="delete from test where id=?";          pstmt = con.prepareStatement(sql);             pstmt.setInt(1,1);             pstmt.executeUpdate();            System.out.println("資料刪除成功!");        }catch (Exception e) {            System.out.println("資料刪除失敗!");            e.printStackTrace();        }    }    public static void close() {     try{      if(rs!=null)             rs.close();      if(stmt!=null)             stmt.close();      if(con!=null)             con.close();     }catch(Exception e)     {      e.printStackTrace();     }    }    }

java串連mysql資料庫範例