txt.java

来自「图书管理系统。JSP+Struts(MVC框架)sql2000数据库」· Java 代码 · 共 20 行

package com.test;

import java.sql.*;
import com.tool.JDBCConnection;


public class txt {
    public static void main(String[]args) {
        JDBCConnection jc=new JDBCConnection();
        //TBBookSortActionForm tt;
        //String sql="insert into tb_manager values('"+bookForm.getId()+"',"+bookForm.getBookNumber()+","+bookForm.getLineNumber()+","+bookForm.getBookName()+","+bookForm.getAuthor()+","+bookForm.getPublish()+","+bookForm.getPublishNumber()+","+bookForm.getSortNumber()+",'"+bookForm.getInPirce()+"','"+bookForm.getSinglePirce()+"','"+bookForm.getBookSum()+"',"+bookForm.getMan()+","+bookForm.getCreatetime()+")";
        ResultSet rs=jc.executeQuery( "select * from tb_bookSort");
        try{
         while(rs.next()){
         System.out.println(rs.getString("sortName"));
         }
        }catch(SQLException se){}
    }
}