JAVA连接mysql数据库的基本实例代码

最新推荐文章于 2023-08-10 11:30:15 发布

kongyu951024

最新推荐文章于 2023-08-10 11:30:15 发布

阅读量365

点赞数 1

本文链接：https://blog.csdn.net/kongyu951024/article/details/88235483

版权

public static final String DBDRIVER = "com.mysql.cj.jdbc.Driver";
	public static final String DBURl = "jdbc:mysql://localhost:3306/Student?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai";
	
	public static final String DBUSER = "root";
	public static final String DBPASS = "qwert123";
	public static void main(String[] args) throws Exception{
		Connection conn = null;
		PreparedStatement pstmt = null;
		String sql = "INSERT INTO STUDENT VALUES(?,?,?,?,?,?)";
		try {
			Class.forName(DBDRIVER);
		} catch (ClassNotFoundException e) {
			// TODO: handle exception
			System.out.println("找不到驱动程序类，加载失败");
			e.printStackTrace();
		}
		try {
			conn = DriverManager.getConnection(DBURl,DBUSER,DBPASS);
			if(conn!=null){
				System.out.println("连接数据库成功");
			}else {
				System.out.println("连接数据库失败");
			}
		} catch (SQLException se) {
			// TODO: handle exception
			se.printStackTrace();
		}
		
		
		int Id = 1003;
		String Name = "liudehua";
		String Sex = "man";
		String Class = "class four";
		int Score = 100;
		String Remark = "exchange student";
		
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, Id);
			pstmt.setString(2,Name);
			pstmt.setString(3,Sex);
			pstmt.setString(4,Class);
			pstmt.setInt(5, Score);
			pstmt.setString(6,Remark);
			pstmt.executeUpdate();
			if(pstmt!=null)
				pstmt.close();
			if (conn!=null) 
				conn.close();
		} catch (Exception e) {
			// TODO: handle exception
			System.out.println(e.getMessage());
		}
		
		
		
	}