<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" %> <%@ include file="Connections/vaio.jsp" %> <% // *** Edit Operations: declare variables // set the form action variable String MM_editAction = request.getRequestURI(); if (request.getQueryString() != null && request.getQueryString().length() > 0) { MM_editAction += "?" + request.getQueryString(); } // connection information String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null; // redirect information String MM_editRedirectUrl = null; // query string to execute StringBuffer MM_editQuery = null; // boolean to abort record edit boolean MM_abortEdit = false; // table information String MM_editTable = null, MM_editColumn = null, MM_recordId = null; // form field information String[] MM_fields = null, MM_columns = null; %> <% // *** Insert Record: set variables if (request.getParameter("MM_insert") != null && request.getParameter("MM_insert").toString().equals("form1")) { MM_editDriver = MM_vaio_DRIVER; MM_editConnection = MM_vaio_STRING; MM_editUserName = MM_vaio_USERNAME; MM_editPassword = MM_vaio_PASSWORD; MM_editTable = "survey_data"; MM_editRedirectUrl = "../linux2.html"; String MM_fieldsStr = "survey_id|value|model|value|year|value|new|value|OS|value|OS2|value|OS3|value|screen|value|screen_size|value|keyboard|value|mouse|value|peripheral|value|network|value|apps|value|notes|value|mail|value|date|value"; String MM_columnsStr = "survey_id|none,none,NULL|model|',none,''|year|none,none,NULL|new|',none,''|OS|',none,''|OS2|',none,''|OS3|',none,''|screen|',none,''|screen_size|',none,''|keyboard|',none,''|mouse|',none,''|peripheral|',none,''|network|',none,''|apps|',none,''|notes|',none,''|mail|',none,''|date|',none,NULL"; // create the MM_fields and MM_columns arrays java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_fieldsStr,"|"); MM_fields = new String[tokens.countTokens()]; for (int i=0; tokens.hasMoreTokens(); i++) MM_fields[i] = tokens.nextToken(); tokens = new java.util.StringTokenizer(MM_columnsStr,"|"); MM_columns = new String[tokens.countTokens()]; for (int i=0; tokens.hasMoreTokens(); i++) MM_columns[i] = tokens.nextToken(); // set the form values for (int i=0; i+1 < MM_fields.length; i+=2) { MM_fields[i+1] = ((request.getParameter(MM_fields[i])!=null)?(String)request.getParameter(MM_fields[i]):""); } // append the query string to the redirect URL if (MM_editRedirectUrl.length() != 0 && request.getQueryString() != null) { MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + request.getQueryString(); } } %> <% // *** Insert Record: construct a sql insert statement and execute it if (request.getParameter("MM_insert") != null) { // create the insert sql statement StringBuffer MM_tableValues = new StringBuffer(), MM_dbValues = new StringBuffer(); for (int i=0; i+1 < MM_fields.length; i+=2) { String formVal = MM_fields[i+1]; String elem; java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_columns[i+1],","); String delim = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:""; String altVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:""; String emptyVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:""; if (formVal.length() == 0) { formVal = emptyVal; } else { if (altVal.length() != 0) { formVal = altVal; } else if (delim.compareTo("'") == 0) { // escape quotes StringBuffer escQuotes = new StringBuffer(formVal); for (int j=0; j < escQuotes.length(); j++) if (escQuotes.charAt(j) == '\'') escQuotes.insert(j++,'\''); formVal = "'" + escQuotes + "'"; } else { formVal = delim + formVal + delim; } } MM_tableValues.append((i!=0)?",":"").append(MM_columns[i]); MM_dbValues.append((i!=0)?",":"").append(formVal); } MM_editQuery = new StringBuffer("insert into " + MM_editTable); MM_editQuery.append(" (").append(MM_tableValues.toString()).append(") values ("); MM_editQuery.append(MM_dbValues.toString()).append(")"); if (!MM_abortEdit) { // finish the sql and execute it Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance(); Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword); PreparedStatement MM_editStatement = MM_connection.prepareStatement(MM_editQuery.toString()); MM_editStatement.executeUpdate(); MM_connection.close(); // redirect with URL parameters if (MM_editRedirectUrl.length() != 0) { response.sendRedirect(response.encodeRedirectURL(MM_editRedirectUrl)); return; } } } %> <% Driver Drivervaio = (Driver)Class.forName(MM_vaio_DRIVER).newInstance(); Connection Connvaio = DriverManager.getConnection(MM_vaio_STRING,MM_vaio_USERNAME,MM_vaio_PASSWORD); PreparedStatement Statementvaio = Connvaio.prepareStatement("SELECT * FROM survey_data"); ResultSet vaio = Statementvaio.executeQuery(); boolean vaio_isEmpty = !vaio.next(); boolean vaio_hasData = !vaio_isEmpty; Object vaio_data; int vaio_numRows = 0; %> Linux on VAIO
Linux on the Sony VAIO C1XD

Links:

Linux on Laptops
several pages on C1 type machines to get you started

Other Linux on C1XD/XS pages

C1XS | C1XS

C1 pages mostly Windows (for those times when you "have" to)

C1

Mostly WIndows mailing list

C1-forum-subscribe@frijoles.hungry.com

 

A quick and nasty C1 survey

Reply number:
Model:
Year bought:
New:



You can give the first three operating systems in use on the C1:
OS1:
OS2:
OS3:
External screen:



Screen_size:
External keyboard:



Mouse:



Other peripherals:
Network used:
Principal applications used:
Notes:
We require a valid e-mail address for your replies to be taken into account. It will not appear on the results. It will not be used to contact you.
e-Mail:
 

 

  
  All trademarks, brand names etc. used on this page are probably registered and owned by the companies mentioned herein.

October 22, 2002 © tgds 2002 | tgrant@tgds.net | Privacy
<% vaio.close(); Statementvaio.close(); Connvaio.close(); %>