数据库的增删改查:
创建数据库连接:
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();
}
}