dbcon.java

JSP工程应用与实践

package bean;
import java.sql.*;
public class dbcon
  {
  	private  	int temp=0;
    public int insert(String str)
  	  {
  	  	  try{
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  	           Connection con;
           	   Statement stmt;
               con=DriverManager.getConnection("jdbc:odbc:prodb");
               stmt=con.createStatement();
               temp=0;
               temp=stmt.executeUpdate(str);
            }
 		  catch (Exception e)
            {
              System.out.println(e);
              temp =0;
            }
                return temp;
  	  }
 }