1.创建表users
2.测试是否成功连接数据库
3.访问数据库
代码
package myjdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class JDBCTest {
/*
* liuxin
* 1.加载驱动
* 2.建立连接
* 3.创建sql语句
* 4.执行sql语句返回结果集
* 5。分析结果集
* 6.释放资源
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection connection=null;
PreparedStatement preparedStatement=null;
ResultSet resultSet=null;
String url = "jdbc:mysql://localhost:3306/lx_batis?useUnicode=true&characterEncoding=UTF-8" ;
String username = "root" ;
String password = "123456" ;
try {
Class.forName("com.mysql.jdbc.Driver") ;
connection=DriverManager.getConnection(url , username , password ) ;
System.out.println("数据库连接成功!");
String sql="select *from users where name=?";
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setString(1, "张三");
resultSet=preparedStatement.executeQuery();
while(resultSet.next()){
System.out.println(resultSet.getString("id")+" "+resultSet.getString("name"));
}
} catch (Exception e) {
// TODO: handle exception
System.out.println("数据库连接失败!");
}finally{
if(resultSet!=null){
try {
resultSet.close();
preparedStatement.close();
connection.close();
} catch (Exception e2) {
// TODO: handle exception
}
}
}
}
}
4.解决eclipse连接mysql数据库进行查询时不能匹配中文的问题
首先确保数据库与eclipse字符集都为utf-8
查询数据库张三访问不到,在url中加如下即可,就可以访问到了useUnicode=true&characterEncoding=UTF-8