数据库连接PreparedStatement

package zn;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.PreparedStatement;

public class database2 {

	public static void main(String[] args) throws SQLException {
		// TODO Auto-generated method stub
		//数据库MySQL,用preparedstatement对象来执行对表的插入并输出
		//3306 数据库端口  znzn数据库名  root 数据库管理员 123456数据库密码
		String driver="com.mysql.jdbc.Driver";
		String url="jdbc:mysql://localhost:3306/znzn";
		String username="root";
		String password="123456";
		String sql3="insert into tb1(id, name)value(?,?)";//插入语句
		Connection conn=null;
		PreparedStatement pstmt=null;
		int n;
		try{
			Class.forName(driver);
			conn=DriverManager.getConnection(url,username,password);
			pstmt= (PreparedStatement) conn.prepareStatement(sql3) ; //给预编译Statement对象初始化
			pstmt.setInt(1, 23);
			pstmt.setString(2, "LY");
			n=pstmt.executeUpdate();
		
			if(n==0){
				System.out.println("没有成功");
			}else{
				System.out.println("添加成功");
			}
			pstmt.close();
			conn.close();
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch (SQLException e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}

}