下午写了点java实现的mysql数据库的基本功能实现,sql语句和java程序的互通其实也就那么回事。
表设计如下
第一步:设计表如下
第二步,导入mysql-connector
第三步,敲代码
注意:3306是mysql服务器的端口号,ctk是我自己创建的root下的一个数据库,localhost表示本地的意思
String url="jdbc:mysql://localhost:3306/ctk";
代码如下:
package Databases_connect;
import java.sql.*;
/**
* 1.增加数据-insert into student(school,name) values(?,?)
* public void dd2Table(String school,String name);
* public void add2Table(String school,String name,int id);
* 2.删除数据-delete from student where stu_id = ?
* public void DelData(int id)
* 3.查找数据-select * from student
* public void SelectTables()
* 4.修改数据-update student set school=?,name=? where stu_id=?
* public void upData(String school,String name,int id)
*
*
*
* @author me
*
*/
public class DAO_mysql {
/*
数据库加载固定属性
*/
String driver="com.mysql.jdbc.Driver";
Connection con;
String url="jdbc:mysql://localhost:3306/ctk";
String user="root";
String pwd="123456c";
//连接上数据库mysql
public void connection2MYSQL()
{
try {
Class.forName(driver);
con=DriverManager.getConnection(url,user,pwd);
if(!con.isClosed())
System.out.println("连接成功");
} catch (Exception e) {
e.printStackTrace();
}
}
//增加一栏数据
public void add2Table(String school,String name)
{
try {
//预处理命令添加
PreparedStatement sql;
sql = con.prepareStatement("insert into student(school,name) values(?,?)");
sql.setString(1,school);
sql.setString(2,name);
sql.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
//增加一栏数据-----指定id
public void add2Table(String school,String name,int id)
{
try {
//预处理命令添加
PreparedStatement sql;
sql = con.prepareStatement("insert into student(school,name,stu_id) values(?,?,?)");
sql.setString(1,school);
sql.setString(2,name);
sql.setInt(3, id);
sql.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
//查找表中所有数据
public void SelectTables(){
try {
// 执行sql语句
Statement statement = con.createStatement();
String sql = "select * from student";
ResultSet rs = statement.executeQuery(sql);
String name = "";
String school = "";
int id;
while (rs.next()) {
school = rs.getString("school");
name = rs.getString("name");
id=rs.getInt("stu_id");
System.out.println("name =" + name + " school=" + school+" id="+id);
}
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
}
//删除一行数据
public void DelData(int id)
{
try {
PreparedStatement sql;
sql = con.prepareStatement("delete from student where stu_id = ?");
sql.setInt(1,id);
sql.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
//修改一栏数据
public void upData(String school,String name,int id)
{
try {
PreparedStatement sql;
sql = con.prepareStatement("update student set school=?,name=? where stu_id=?");
sql.setString(1,school);
sql.setString(2,name);
sql.setInt(3, id);
sql.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
//主函数
public static void main(String[] args)
{
try {
d.con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
图如下,不要说我坑你,主函数自己写
大致流程的核心代码如下:
String driver="com.mysql.jdbc.Driver";
Connection con;
String url="jdbc:mysql://localhost:3306/ctk";
String user="root";
String pwd="123456c";
public void connection2MYSQL()
{
try {
Class.forName(driver);
con=DriverManager.getConnection(url,user,pwd);
if(!con.isClosed())
System.out.println("连接成功");
} catch (Exception e) {
e.printStackTrace();
}
噢耶,完了
}