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.createStat