package com.cmesn.struts.action;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class left_list {
	public static  String mysqlDriver="com.mysql.jdbc.Driver";   
	public static String mysqlUrl="jdbc:mysql://localhost:3306/cmesn?useUnicode=true&characterEncoding=gbk"; 
	public static String conn_user = "root"; 
	public static String conn_password ="root"; 
	Connection con =null;
	Statement st =null;
	ResultSet rs =null;
	
	 public  ResultSet check(String sql){
		   try{
			   Class.forName(mysqlDriver);
		       con = DriverManager.getConnection(mysqlUrl,conn_user,conn_password);
			   st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			   rs =st.executeQuery(sql);
			   return rs;
		   }catch(ClassNotFoundException e){
			   e.printStackTrace();
		   }catch(SQLException el){
			   el.printStackTrace();   
		   }
		  return rs;
	      }

	 public  int update(String sql){
		 int x=0;
		   try{
			   Class.forName(mysqlDriver);
		       con = DriverManager.getConnection(mysqlUrl,conn_user,conn_password);
			   st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			   x =st.executeUpdate(sql);
			   return x;
		   }catch(ClassNotFoundException e){
			   e.printStackTrace();
		   }catch(SQLException el){
			   el.printStackTrace();   
		   }
		   return x;
	      }
}