Java编写jdbc连接mysql数据库

1、新建项目

2、这里需要导入mysql-connector-java-5.1.38.jar包，你可以在mvn搜索mysql 下载

3、然后怎么导入百度一下就可以了

4、新建com.liming.tee.bean包->User类

package com.liming.tee.bean;


public class User {

/ /这里定义的字段id，name，password需要跟数据库定义的字段一样
private int id;
private String name;
private String password;

public User(){

}

public User(int id, String name, String password) {
super();
this.id = id;
this.name = name;
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}




}

5、新建一个JDBC类

package com.liming.tee.bean;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


import com.liming.tee.bean.User;


public class JDBC {
static String sql = null;  
static PreparedStatement pst =null;
   //static DBHelper db1 = null;  
static ResultSet ret = null; 
static Connection conn=null;

static User us=new User();

public static void getConnection(){
try {
Class.forName("com.mysql.jdbc.Driver");

/ /@localhost：数据库地址；@3306：数据库端口号；@user：数据库名称；@root：数据库用户名称；@123456：数据库密码
conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/user?characterEncoding=utf8&useSSL=true", "root", "123456");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}

public static void add(){
String sql="insert into user values(1004,'admin','admin')";
try {
pst = conn.prepareStatement(sql);
int num = pst.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void Select() throws SQLException{
getConnection();
sql = "select *from user";//SQL语句  
        //db1 = new DBHelper(sql);//创建DBHelper对象  
pst=conn.prepareStatement(sql);

            ret = pst.executeQuery();//执行语句，得到结果集  
            while (ret.next()) {  
                int id = ret.getInt(1);  
                String name = ret.getString(2);  
                String password = ret.getString(3);  
               
                System.out.println(id + "\t" + name + "\t" + password);  
            }//显示数据  
            ret.close();  
           // db1.close();//关闭连接  
}
public static void delete(){
String sql="delete from user where id=1001";
try {
PreparedStatement ps =conn.prepareStatement(sql);
//ps.setLong(1, us.getId());
ps.executeUpdate();
ps.close();
} catch (SQLException e) {

e.printStackTrace();
}
} 
public static void Update(){
String sql="update user set user.id=?,user.name=?,user.password=? where id=1001";
try {
pst =conn.prepareStatement(sql);
pst.setLong(1,1006);
pst.setString(2,"wangt");
pst.setString(3,"Password");
pst.executeUpdate();
pst.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

/ / 以上都是静态方法，可以直接调用
public static void main(String[] args){

/ /先建立连接
getConnection();

/ / 往数据库添加数据

add();

/ /删除数据库数据

delete();

/ /修改数据库中的信息
Update();
}
}

6、数据库表