testsql.java

用JSP做的 数据库和源代码绝对保真 欢迎大家交流使用

package sql;
import java.sql.*;
import javax.swing.*;

import javax.swing.JOptionPane;
public class Testsql
{
	public static String getConnectionUrl()
	{String url="jdbc:sqlserver://";
	String serverName="localhost";
	String portNumber="1433";
	String databaseName="BSMS";
	return url+serverName+":"+portNumber+";databaseName="+databaseName;
	
	}


public static void main(String[] args)
{
	//String query="insert into admintable(adminname,code)"+"values(1111,3333)";
	//String query="updata admintable set adminname=？,code=？";
			
	String query="select * from admintable";
	//String query="delete from admintable where code=3333";
	try
	{
	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	Connection con=DriverManager.getConnection(getConnectionUrl(),"sa","5201314");
	Statement stmt=con.createStatement();
	ResultSet rs=stmt.executeQuery(query);
	JOptionPane.showMessageDialog(null,"成功！！!");

	while(rs.next())
	{String s=rs.getString(1);
	 String f=rs.getString(2);
	 System.out.print(s+""+f);
	}
	stmt.close();
	con.close();
	}
	catch(SQLException sqlex){
		sqlex.printStackTrace();
		
	}
	catch(Exception ex)
	{ex.printStackTrace();}
	
}
}