text.java

来自「我们做的J2EE课程设计实验,使用JSF语言编写一个简易的订单系统,麻雀虽小五脏」· Java 代码 · 共 60 行

import java.sql.*;

public class Text 
{
	     public static void main(String args[])
	     {  
	         String RL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Result";
	         String user ="sa";//默认是sa，这里替换成你自已的数据库用户名
	         String password = "bigtwo863158";//默认为空，这里替换成你自已的数据库用户密码
	         String sqlStr = "select * from Re";

	         try{     //这里的异常处理语句是必需的.否则不能通过编译!    
	             Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	             System.out.println( "类实例化成功!" );
	             System.out.println("slkdjf");
	             Connection con = DriverManager.getConnection(RL,user,password);
	             System.out.println( "创建连接对像成功!" );

	             Statement st = con.createStatement();
	             System.out.println( "创建Statement成功!" );
	             try{
	             PreparedStatement pstmt=con.prepareStatement("insert into re values(?,?,?,?,?)");
	             String ab="ab";
	             String ef="ef";
	             String gh="gh";
	             String cd="cd";
	             String ak="ak";
	             pstmt.setString(1,ab);
	         	 pstmt.setString(2,ef);
	         	 pstmt.setString(3,gh);
	         	 pstmt.setString(4,cd);
	         	 pstmt.setString(5,ak);
	         	 pstmt.executeUpdate();
	             }catch(Exception e)
	             {
	            	 
	             }
	             ResultSet rs = st.executeQuery( sqlStr );
	             System.out.println( "操作数据表成功!" );
	             System.out.println( "----------------!" );
                 
	             while(rs.next())
	             {
	                 System.out.print(rs.getString("Name") + "     ");
	                 System.out.print(rs.getString("Number") + "     ");
	                 System.out.print(rs.getString("Chinese") + "     ");
	                 System.out.print(rs.getString("Maths") + "     ");
	                 System.out.println(rs.getString("English"));
	             }
	             rs.close();
	             st.close();
	             con.close();
	         }
	         catch(Exception err){
	             err.printStackTrace(System.out);
	         }
	     }
	}