jdbc测试类代码mysql_java JDBC测试(示例代码)

package com.jdbc.test;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.mysql.jdbc.Connection;public classJdbcTest1 {public staticConnection getConnection(){

Connection conn= null;try{

Class.forName("com.mysql.jdbc.Driver");　　//加载驱动

conn= (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=utf-8&useSSL=false","root","123456");　　//连接数据库

}catch (ClassNotFoundException |SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}returnconn;

}public static void select(){

Connection conn=getConnection();

String sql= "select *from book1";try{

Statement st=conn.createStatement();

ResultSet rs=st.executeQuery(sql);　　//执行SQL语句while(rs.next()){

System.out.print(rs.getString("use_name")+" ");

System.out.println(rs.getInt("use_age")+" ");

}

rs.close();

st.close();

conn.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}public static voidinsert(){

Connection conn=getConnection();

String sql= "insert into book1 values(‘lixiaoming‘,25)";try{

Statement st=conn.createStatement();int count =st.executeUpdate(sql);

System.out.println("已经向表中插入"+count+"条数据");

st.close();

conn.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}public static voiddelete(){

Connection conn=getConnection();

String sql= "delete from book1 where use_age = 25";try{

Statement st=conn.createStatement();int count =st.executeUpdate(sql);

System.out.println("从表中删除了"+count+"条数据");

st.close();

conn.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}public static voidupdate(){

Connection conn=getConnection();

String sql= "update book1 set use_age=30 where use_name = ‘zhangsan‘";try{

Statement st=conn.createStatement();int count =st.executeUpdate(sql);

System.out.println("从表中更新了"+count+"条数据");

st.close();

conn.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}public static voidmain(String[] args) {//TODO Auto-generated method stub

select();//insert();//delete();//update();

}

}