connect.java

来自「自己做的毕业设计」· Java 代码 · 共 45 行

package db;

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

public class Connect {
	public Connection con=null;
	public Statement st=null;
	public ResultSet rs=null;
	public int num=0;
	public Connect(String s)
	{
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:netshop9","system","9999");
			if (con==null) {System.out.println("heihei");}
			st=con.createStatement();
			rs=st.executeQuery(s);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public Connect(String s,String i)
	{
		if ("insert".equals(i))
		{
		try {
			con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:netshop9","system","9999");
			st=con.createStatement();
			num=st.executeUpdate(s);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		}
	}
}