import com.mysql.jdbc.Driver;
import java.sql.*;
public class JDBCDemo {
public static void main(String[] args) throws Exception {
//1 获取连接
String url = "jdbc:mysql://IP:Port/db_name";
String username = "username ";
String password = "password ";
Connection conn = DriverManager.getConnection(url, username, password);
//2 sql 语句
String sql = "select * from account where name=?";
//3 获取执行sql的对象
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, "青云ing");
//4 执行sql
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
System.out.println("-----------------");
System.out.println("ID:" + rs.getInt("id") + " Name:" + rs.getString("name") + " Age:" + rs.getInt("age"));
}
//6 释放资源
stmt.close();
conn.close();
}
}
JDBC参数化查询示例
最新推荐文章于 2024-06-22 22:33:44 发布