java : jdbc PreparedStatement

最新推荐文章于 2023-10-03 23:29:28 发布

转载最新推荐文章于 2023-10-03 23:29:28 发布 · 526 阅读

文章标签：

#java #jdbc

java 专栏收录该内容

41 篇文章

订阅专栏

本文提供了一个使用 Java 进行 SQL 数据库查询的示例代码。该程序通过命令行接收参数，利用 MySQL JDBC 驱动连接本地数据库，并执行带有 IN 子句的 SQL 语句来查询指定的数据。

示例 Query1.java

import java.sql.*;

public class Query1 {
	public static void main(String[] args){
		String code;
		String city;
		String sh;
		String cname;
		
		if (args.length ==1){
			code = args[0];
			city = code.substring(0,4)+"00";
			sh = code.substring(0,2)+"0000";
		} else {
			System.out.println(" usage: java Query2 ?????? ");
			return;
		}
		try{
			Connection conn = null;
			PreparedStatement stmt = null;
			ResultSet rs = null;
			
			DriverManager.registerDriver(new com.mysql.jdbc.Driver());
			String url = "jdbc:mysql://localhost:3306/test";
			conn = DriverManager.getConnection(url,"user","pass");
			String sql = "select code,cname from table where code in (?,?,?)";
			stmt = conn.prepareStatement(sql);
			stmt.setString(1, sh);
			stmt.setString(2, city);
			stmt.setString(3, code);
			rs = stmt.executeQuery();
			
			while(rs.next()){
				code = rs.getString(1);
				cname = rs.getString(2);
				System.out.println(code+" "+cname);
			}
			rs.close();
			stmt.close();
			conn.close();
		}
		catch (Exception e){
			System.out.println(e);
		}
	}
			
}

运行 java -cp mysql-connector-java-5.1.24-bin.jar;. Query1 440108