jdbcdemo1.java

JSP效果信息 各位请下载查看 比较不错的

import javax.swing.JOptionPane;
import java.sql.*;
class JdbcDemo1{
	public static void main(String args[]){
		Connection con;
		Statement st;
		ResultSet rs;
		String user="sa",pass="123456",s,s1,s2,ss;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}catch(ClassNotFoundException e){
  			  System.out.println("类未找到错误！"+e);
  		}
  		try{
  	        con=DriverManager.getConnection("jdbc:odbc:master",user,pass);
  	        while(true){
  	        	s=JOptionPane.showInputDialog("请选择：\n 1.显示记录\n 2.添加记录\n 3.删除记录\n 4.退出");
  	        	st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
  	        	rs=st.executeQuery("select * from 学生成绩");
  	        	if(s.equals("1")){
  	        		s1=JOptionPane.showInputDialog("请输入[开始记录号(>=1),记录数]");
  	        		String sa[]=s1.split(",");
  	        		listRecord(rs,Integer.parseInt(sa[0]),Integer.parseInt(sa[1]));
  	        		}else if(s.equals("2")){
  	        			s1=JOptionPane.showInputDialog("请输入[考号，姓名，性别，出生日期，数学，语文，英语，综合]");
  	        			String a[]=s1.split(",");
  	        			ss="insert into 学生成绩 values('"+a[0]+"','"+a[1]+"','"+a[2]+"',"+a[3]+","+a[4]+","+a[5]+","+a[6]+","+a[7]+")";
  	        			JOptionPane.showMessageDialog(null,"添加记录的SQL语句是：\n"+ss);
  	        			st.executeUpdate(ss);
  	        			}else if(s.equals("3")){
  	        		        s1=JOptionPane.showInputDialog("请输入要删除记录的学生号：");
  	        		        PreparedStatement ps=con.prepareStatement("delete from 学生成绩 where 考号=?");
  	        		        ps.setString(1,s1);
  	        		        ps.executeUpdate();
  	        				}else{
  	        					rs.close();
  	        					st.close();
  	        					con.close();
  	        					System.exit(0);
  	        					}
  	        	}
  			}catch(java.sql.SQLException e){
  		     System.out.println("SQL错误！"+e);
  	        }
		}
		static void listRecord(ResultSet rs,int start,int n)throws SQLException{
			int i=1;
			String ss="";
			rs.absolute(start);
			while(i<=n){
				ss+=rs.getString(1)+"|";
				ss+=rs.getString(2)+"|";
				ss+=rs.getString(3)+"|";
				ss+=rs.getString(4).substring(0,10)+"|";
				ss+=rs.getString(5)+"|";
				ss+=rs.getString(6)+"|";
				ss+=rs.getString(7)+"|";
				ss+=rs.getString(8);
				ss+="\n";
				i++;
				if(!rs.next())
				  break;
				}
			JOptionPane.showMessageDialog(null,"显示记录如下：\n"+ss);
			}
	}