数据库增删改查

数据库的增删改查：
创建数据库连接：
package dd;

import java.sql.*;

public class DBHelper {

private static Connection Conn; 
private static String URL = "jdbc:mysql://localhost:3306/myschool?characterEncoding=utf8&useSSL=true";
private static String UserName = "root";
private static String Password = "1234";  
public static Connection getConnection() {

    try {

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

        System.out.println("加载驱动成功!!!");
    } catch (ClassNotFoundException e) {
        // TODO: handle exception
        e.printStackTrace();
    }

    try {

        //通过DriverManager类的getConenction方法指定三个参数,连接数据库
        Conn = DriverManager.getConnection(URL, UserName, Password);
        System.out.println("连接数据库成功!!!");

        //返回连接对象
        return Conn;

    } catch (SQLException e) {
        // TODO: handle exception
        e.printStackTrace();
        return null;
    }
}

}
如下代码即是增加
package dd;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import dd.DBHelper;

public class addsql {

// 连接对象
private Connection conn;
// 传递sql语句
private Statement stt;
// 结果集
private ResultSet set;

// 查询
public void Select() {
    try {
        // 获取连接
        conn = DBHelper.getConnection();
        if (conn == null)
            return;
        // 定义sql语句
        String Sql = "select * from login";
        // 执行sql语句
        stt = conn.createStatement();
        // 返回结果集
        set = stt.executeQuery(Sql);
        // 获取数据
        while (set.next()) {

            System.out.println("用户名:" + set.getString(1) + "\t密码:"
                    + set.getString(2));

        }

    } catch (Exception e) {
        e.printStackTrace();
    } finally {

        // 释放资源
        try {
            set.close();
            conn.close();
        } catch (Exception e2) {
            // TODO: handle exception
        }

    }
}

}
如下代码包括了数据库的删除 修改 查看
package dd;
public class delete {
public void Add(){
try {
//获取连接
conn = DBHelper.getConnection();
if(conn==null)
return conn;
Scanner input = new Scanner(System.in);
System.out.print(“请输入用户名:”);
int user = input.nextInt();
System.out.print(“请输入密码:”);
String pwd = input.next();
//定义sql语句
String sql = “insert into login values(”+user+" , ‘"+pwd+"’);";
//获取Statement对象
stt = conn.createStatement();
//执行sql语句
stt.executeUpdate(sql);

    } catch (Exception e) {
        e.printStackTrace();
    }finally{
        //释放资源
        try {
            
            conn.close();
            
        } catch (Exception e2) {}
        
    }

}

} 

public void Delete(){
        try {
            
            //获取连接
            conn = DBHerpel.getConnection();
            if(conn==null)
            return;
            
            //提示用户输入要删除的用户
            System.out.print("请输入删除的用户:");
            Scanner input = new Scanner(System.in);
            int user = input.nextInt();
            
            //定义sql语句
            String deleteSql = "DELETE FROM login WHERE user="+user+";";
            //获取Statement对象
            stt = conn.createStatement();
            //执行sql语句
            stt.executeUpdate(deleteSql);
	        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            //释放资源
            try {
                conn.close();
                
            } catch (Exception e2) {}
            
        }
    }

}

public void Update(){

try {
    //获取连接
    conn = DBHerpel.getConnection();
    if(conn==null)
        return;
    System.out.print("请输入用户名:");
    Scanner input = new Scanner(System.in);
    int user = input.nextInt();
    System.out.print("请输入新的密码:");
    String NewPwd = input.next();
    //定义Sql语句
    String UpdateSql = "UPDATE login SET pwd = '"+NewPwd+"' WHERE user = "+user+";";
    //创建Statement对象
    PreparedStatement ps = conn.prepareStatement(UpdateSql);
    //执行sql语句
    ps.executeUpdate();
} catch (SQLException e) {
    
    e.printStackTrace();
}finally{
    try {
        conn.close();
    } catch (Exception e2) {}
    
}

}

数据库的测试命令：
package dd;
import dd.visitServer.VisitMySql;
public class Test {

    public static <VisitMySql> void main(String[] args){
        
        VisitMySql vs = new VisitMySql();
       //调用查询方法
        vs.Select();
      	        
        
    }

}