amw0007
发贴: 0
积分: 0
|
于 2004-02-02 13:08
import java.sql.*; import javax.sql.*; import com.microsoft.jdbc.sqlserver.*;
public class createtable { Connetion conn=null; ResuldSet rs=null; StateMent stmt=null; String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String connURL="jdbc:microsoft:sqlserver://jav:1433;User=sa;password=00781127;DatabaseName=sales"; String name,age,address,email,str; public void LoadDriver() { try { Class.forName(driverName); } catch(ClassNotFoundException e) { System.err.printn("LoadDriver():Failed"+e.getMessage()); } } public void Modify() { try { conn=DriverManager.getConnetion(connUrl); stmt=conn.createStateMent(); str="CREATE TABLE customer(cName VARCHAR(10),cAge SMALLINT,cAddress VARCHAR(20))"; stmt.executeUpdate(str); str="ALTER TABLE customer ADD cMail VARCHAR(20)"; stmt.executeUpdate(str); str="INSERT INTO customer(cName,cAge,cAddress,cMail) value ('Mike',45,'nNewYork',mioen@315.net')"; stmt.executeUpdate(str); str="INSERT INTO customer(cName,cAge,cAddress,cMail) value ('success',27,'yuann','fly@21cn.com')"; stmt.executeUpdate(str); str="INSERT INTO customer(cName,cAge,cAddress,cMail) value ('huang',30,'guangxi','name@263.net')"; stmt.executeUpdate(str); rs=stmt.executeQuery("select * from customer"); while(rs.next()) { name=rs.getString("cName"); age=rs.getString("cAge"); address=rs.getString("cAddress"); email=rs.getString("cMail"); System.out.println(name+" "+age+" "+address+" "+email); } conn.close(); stmt.close(); rs.close(); } catch(SQLException sqle) { System.err.println(sqle.getMessage()); } } public static void main(String args[]) { createtable create=new createtable(); create.LoadDriver(); create.Modify(); }
编译后出错 D:\JCreator Pro\MyProjects\apple\createtable.java:7: cannot resolve symbol symbol : class Connetion location: class createtable Connetion conn=null; ^ Connection
D:\JCreator Pro\MyProjects\apple\createtable.java:8: cannot resolve symbol symbol : class ResuldSet location: class createtable ResuldSet rs=null; ^ ResultSet
D:\JCreator Pro\MyProjects\apple\createtable.java:9: cannot resolve symbol symbol : class StateMent location: class createtable StateMent stmt=null; ^ Statement
D:\JCreator Pro\MyProjects\apple\createtable.java:21: cannot resolve symbol symbol : method printn (java.lang.String) location: class java.io.PrintStream System.err.printn("LoadDriver():Failed"+e.getMessage()); ^ println
D:\JCreator Pro\MyProjects\apple\createtable.java:28: cannot resolve symbol symbol : variable connUrl location: class createtable conn=DriverManager.getConnetion(connUrl); ^ connURL
5 errors
why edited on 2004-03-29 07:41
|