statement的四个执行方法---executeQuery/executeUpdate/execute/executeBatch---和早期数据库防黑技术

statement的四个执行方法

我先自己写了一个工厂类和配置文件

ConnectionFactory.java

package cn.hncu.utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class ConnectionFactory {
	private static Connection connection=null;
	static{
		try {
			//读取配置文件
			Properties p=new Properties();
			p.load(ConnectionFactory.class.getClassLoader().getResourceAsStream("jdbc.properties"));
			String driver=p.getProperty("driver");
			String url=p.getProperty("url");
			String userName=p.getProperty("userName");
			String password=p.getProperty("password");
			
			Class.forName(driver);
			connection=DriverManager.getConnection(url, userName, password);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public static Connection getConnection(){
		return connection;
	}
	public static void main(String[] args) {
		System.out.println(connection);
	}
}

jdbc.properties

(未设密码)

#mysql
driver=com.mysql.jdbc.Driver
url=jdbc:mysql:///mydata?useUnicode=true&characterEncoding=utf-8
userName=root
password=

1, executeQuery() : 只能执行查询语句