日常笔记java

JDBC内容

JDBC连接mysql

public class TestWorker(){
	main{
		Worker worker = new Worker();
        int updateNums = worker.updateByNo(1,"李四","123");
	}
}

public class Worker(){
	Connection conn = null;
	public Worker() throws SQLException {
		String url = "jdbc:mysql://127.0.0.1/librarysystem";
		String name = "root";
		String password = "password";
		conn = DriverManager.getConnect(url,name,password);
	}

	public int updateByNo(int no,String newName,String newPassword)throws SQLException{
		String sql = "update worker set name = ?,password = ? where no=?";
		PreparedStatement pstmt = conn.prepareStatement(sql);
		pstmt.setString(1,newName);
		pstmt.setString(2,newPassword);
		pstmt.setInt(3,no)
		int updated_nums = pstmt.excuteUpdate();
		return update_nums;
	}
}