Mysql入门---实现CRUD，单表形式

下午写了点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();
  }
  
  噢耶，完了
  
 }