dboperate_admin.java

来自「实现了精品课程的介绍以及上传在下功能的实现。」· Java 代码 · 共 25 行

package aaa;
import java.sql.*;
public class DBOperate_admin
{
	Statement st;
	Connection con;
	ResultSet rs;
	public void  connection() throws Exception
	{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:datastruct","root","");
			st=con.createStatement();
	}
	public ResultSet AdminloginOp(String ID,String password) throws Exception//登录
	{
		connection();
		rs=st.executeQuery("select * from t_admin where AdminID='"+ID+"' and password='"+password+"'");
		return rs;
	}
	
	public void closeCon() throws Exception
	{
		con.close();
	}
}