dbtools.java

来自「是老师给我们的一个JAVA的学生管理系统」· Java 代码 · 共 44 行

package hit;
import java.sql.*;
public class DBTools
{
	Connection con = null;
	Statement stmt = null;
	public DBTools()
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/hit2","root","hitgs");
			stmt = con.createStatement();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql)
	{
		try
		{
			ResultSet rs = stmt.executeQuery(sql);
			return rs;
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
			return null;
		}
	}
	public void executeUpdate(String sql)
	{
		try
		{
			stmt.executeUpdate(sql);
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
	}
}